package com.zb.excel;

import com.alibaba.excel.annotation.ExcelIgnore;
import com.alibaba.excel.annotation.ExcelProperty;
import com.fasterxml.jackson.annotation.JsonFormat;
import io.swagger.annotations.ApiModel;
import io.swagger.annotations.ApiModelProperty;
import lombok.Data;

import java.util.Date;

/**
 * @Author WEN
 * @Date 2024/3/13 0013
 **/
@Data
@ApiModel("工单数据导入")
public class OrderExcelImport {
    @ApiModelProperty(value = "所属品牌商家")
    @ExcelProperty(index = 0)
    private String factory;
    @ApiModelProperty(value = "客户姓名")
    @ExcelProperty(index = 1)
    private String username;

    @ApiModelProperty(value = "客户手机号")
    @ExcelProperty(index = 2)
    private String userPhone;

    @ApiModelProperty(value = "客户报单地址-省")
    @ExcelProperty(index = 3)
    private String province;

    @ApiModelProperty(value = "客户报单地址-市")
    @ExcelProperty(index = 4)
    private String city;

    @ApiModelProperty(value = "客户报单地址-县/区")
    @ExcelProperty(index = 5)
    private String area;

    @ApiModelProperty(value = "客户报单地址-详细地址")
    @ExcelProperty(index = 6)
    private String address;

    @ApiModelProperty(value = "商品一物一码")
    @ExcelProperty(index = 7)
    private String code;

    @ApiModelProperty(value = "商品型号")
    @ExcelProperty(index = 8)
    private String goodsModel;

    @ApiModelProperty(value = "商品规格")
    @ExcelProperty(index = 9)
    private String goodsSpec;

    @ApiModelProperty(value = "商品购买时间")
    @ExcelProperty(index = 10)
    @JsonFormat(pattern = "yyyy-MM-dd")
    private Date goodsBuyTime;

    @ApiModelProperty(value = "工单类型")
    @ExcelProperty(index = 11)
    private String module;

    @ApiModelProperty(value = "工单单号")
    @ExcelProperty(index = 12)
    private String workNo;

    @ApiModelProperty(value = "工单状态")
    @ExcelProperty(index = 13)
    private Integer status;

    @ApiModelProperty(value = "工单等级")
    @ExcelProperty(index = 14)
    private String level;

    @ApiModelProperty(value = "服务商名称")
    @ExcelProperty(index = 15)
    private String network;

    @ApiModelProperty(value = "工程师名称")
    @ExcelProperty(index = 16)
    private String engineer;

    @ApiModelProperty(value = "客服名称")
    @ExcelProperty(index = 17)
    private String emp;

    @ApiModelProperty(value = "报单时间")
    @ExcelProperty(index = 18)
    @JsonFormat(pattern = "yyyy-MM-dd")
    private Date createTime;

    @ApiModelProperty(value = "结单时间")
    @ExcelProperty(index = 19)
    @JsonFormat(pattern = "yyyy-MM-dd")
    private Date endTime;

    @ApiModelProperty(value = "工单质保状态：false-保内，true-保外")
    @ExcelProperty(index = 20)
    private Boolean overinsured;

    @ApiModelProperty(value = "工单质保天数")
    @ExcelProperty(index = 21)
    private Integer warrantyDay;

    @ApiModelProperty(value = "工单内容描述")
    @ExcelProperty(index = 22)
    private String content;

    @ApiModelProperty(value = "Excel消息")
    @ExcelIgnore
    private String excelMsg;

}
